Oracle connector

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. The following table lists the versions that have been tested in the lab setup:

Platforms Version

Linux

  • Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - AWS

  • Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production - GCP



User on source database must have select privileges.

User on target database side must have all privileges and SELECT_CATALOG_ROLE.

Supported data types

The following are the different data types that are tested in our lab setup:

  • VARCHAR

  • VARCHAR2

  • NUMBER

  • FLOAT

  • DATE

  • TIMESTAMP(default)

  • CLOB

  • BLOB(with text)

  • User Defined Types:

    • Collection (Nested table only)

  • Structured data types:

    • XML

    • JSON

  • Hyperscale Compliance restricts the support of the following special characters for a user defined type name: ~!@#$%^&*()\\\"?:;,/\\\\`+=[]{}|<>'-.\")] and also restricts collection of CLOB and BLOB in user defined type.

  • Hyperscale Compliance restricts the support of the following special characters for a database column name: ~!@#$%^&*()\\\"?:;,/\\\\`+=[]{}|<>'-.\")]

Property values

Property

Value

SKIP.LOAD.SPLIT.COUNT.VALIDATION

false

SKIP.UNLOAD.SPLIT.COUNT.VALIDATION

false

For default values, see Configuration settings

Known limitations

  • The length of the algorithm's generated masked data may exceed the target database table's column length resulting in a job failure if the target table columns use CHAR data type with BYTE length semantics to store the multibyte characters in the corresponding column. The workaround is to use an algorithm that should generate mask data with a smaller length.

  • Oracle Load does not support LDAP protocol.

  • Oracle Load does not support Object Identifiers (OIDs).